USE [AccountBook]
GO

/****** Object:  Table [dbo].[BookEntry]    Script Date: 2024/11/24 17:36:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BookEntry](
	[Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[UserId] [int] NOT NULL,
	[Total] [numeric](18, 3) NULL,
	[Position] [smallint] NULL,
	[ProfitAndLoss] [numeric](18, 3) NULL,
	[ProfitAndLossRatio] [smallint] NULL,
	[PopularThemes] [varchar](max) NULL,
	[TodayReview] [varchar](max) NULL,
	[TomorrowPlan] [varchar](max) NULL,
	[Notes] [varchar](max) NULL,
	[Uri] [nvarchar](50) NULL,
	[CreationTime] [datetime] NULL,
	[ModifyTime] [datetime] NULL,
	[StockId] [bigint] NOT NULL,
 CONSTRAINT [PK_BookEntry] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'UserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总资产' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'Total'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'Position'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'盈亏' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'ProfitAndLoss'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'盈亏比' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'ProfitAndLossRatio'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'热门题材' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'PopularThemes'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'今日复盘' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'TodayReview'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'明日计划' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'TomorrowPlan'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'Notes'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分享页面地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookEntry', @level2type=N'COLUMN',@level2name=N'Uri'
GO


